package com.pitop.material.VO;

import com.pitop.core.tools.excel.ExcelColumn;
import lombok.Data;

/**
 * 供应材料导入表头对应VO
 * Created by jiyan on 2018/9/28.
 */
@Data
public class MaterialExcel {
    @ExcelColumn(value = "part No.", col = 1)
    private String num;//数据库字段:num  属性显示:编号
    @ExcelColumn(value = "description", col = 2)
    private String name;//数据库字段:name  属性显示:名称
    @ExcelColumn(value = "manufacturing No.(or drawing No.)", col = 3)
    private String factoryCode;//数据库字段:factory_code  属性显示:原厂型号编号
    @ExcelColumn(value = "version", col = 4)
    private String materialVerion;//数据库字段:material_verion  属性显示:物料版本号
    @ExcelColumn(value = "minimum order quantity", col = 5)
    private String moq;//数据库字段:moq  属性显示:最小订货量 MOQ
    @ExcelColumn(value = "unit", col = 6)
    private String materialUnit;//数据库字段:materialUnit  属性显示:单位
    @ExcelColumn(value = "unit price", col = 7)
    private String fob;//数据库字段:fob  属性显示:价格
    @ExcelColumn(value = "currency", col = 8)
    private String materialCurrency;//数据库字段:materialCurrency  属性显示:货币
    @ExcelColumn(value = "lead time", col = 9)
    private String cycleTime;//数据库字段:cycle_time  属性显示:生产周期
    @ExcelColumn(value = "alternative", col = 10)
    private String alternative;//无：可替代材料
    @ExcelColumn(value = "commodity", col = 11)
    private String summary;//数据库字段:summary  属性显示:描述 64个汉字描述
    @ExcelColumn(value = "top1 supplier", col = 12)
    private String top1;
    @ExcelColumn(value = "top2 supplier", col = 13)
    private String top2;
    @ExcelColumn(value = "top3 supplier", col = 14)
    private String top3;
}
